TenderAdjustmentTransaction

Entity Definition

Logical Name : TenderAdjustmentTransaction
Physical Name : TR_ADJT_TND

A type of TenderControlTransaction that records the transformation of Tender from one TenderType to another within a Till.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
TillID (FK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer Till(AS_TL)
OriginalTenderTypeCode (FK) A code which uniquely identifies the type of Tender, for which the counts are being adjusted. TY_TND_ORG Code varchar(20) Tender(AS_TND)
NewTenderTypeCode (FK) A code which uniquely identifies the type of Tender to which the tender adjustment is being made. TY_TND_NEW Code varchar(20) Tender(AS_TND)
AdjustmentTypeCode A mnemonic code denoting what kind of adjustment is being made. e.g. Summary, Detailed. TY_ADJT Code4 char(4)
Amount The monetary value of the Tender adjustment (in the default system currency) MO_ADJT MoneyShortRetail decimal(7,2)
ForeignCurrencyAmount The monetary value of the Tender adjustment (in the currency of the Tender being adjusted) MO_ADJT_FRG_CY MoneyShortRetail decimal(7,2)
OriginalCount The original count of Tender items in the Till before the Adjustment. UN_ORG QuantityShortCount decimal(3,0)
NewCount The new count of Tender items in the Till after the Adjustment. UN_NEW QuantityShortCount decimal(3,0)

Relationships

Parent Entity Verb Phrase Child Entity
Tender is source for TenderAdjustmentTransaction
Till is location for TenderAdjustmentTransaction
Tender is destination for TenderAdjustmentTransaction
TenderControlTransaction can be a TenderAdjustmentTransaction

Logical Views containing TenderAdjustmentTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 02500 - Tender Control Transaction - Macro View
Logical 02510 - Tender Control Transaction - Movement View
Logical 03160 - Reporting - Store Operations - Till View
Logical 04200 - Financial Ledger - Tender Ctrl Transaction View